<!DOCTYPE html >
<!--  Website template by freewebsitetemplates.com  -->
 <%@ page import="java.sql.*" %>
<html>

<head>
	<title>Cs</title>
	<meta  charset=iso-8859-1" />
	<link href="css/style.css" rel="stylesheet" type="text/css" />
	<!--[if IE 6]>
		<link href="css/ie6.css" rel="stylesheet" type="text/css" />
	<![endif]-->
	<!--[if IE 7]>
        <link href="css/ie7.css" rel="stylesheet" type="text/css" />  
	<![endif]-->
</head>

<body>

	  
			<div id="header">
	           		<a href="index.html" id="logo"><img src="images/logo.gif" width="310" height="72" alt="" title=""></a>
					<ul class="navigation">
						<li ><a href="index.html">Home</a></li>
						<li class="active"><a href="admin.jsp?label=userview">User_Details</a></li>
						
						
						<li><a href="logout4.jsp">Log out</a></li>
					</ul>
			</div>
			
			<div id="body">
			
			       <div id="content">
				         
						 
						 <div class="search">
									
								</div>
								
				        <div class="content7">
				        <% Object name=null,sid=null; 
				        System.out.println("hello");
				          sid=request.getParameter("eid");
				          name=request.getParameter("name");
				          System.out.println(sid);
						
						      %>

<div style="width:670px;height:auto;float:left; border-radius:5px; padding-right:10px;padding-left:10px;padding-bottom:10px;padding-top:30px;margin-left:10px;margin-top:10px;margin-bottom:10px;border:1px solid #00cc00";>


<!--table start-->
<div class="admintablegenerator" ><font color="green" size="5px";>Details of <%=name %> Email id: <%=sid %></font><br /><br />
                <table >
                    
                    
                    
                    <%
                    byte[]  message2=null,message2key=null;
                    String ad11=new String("");
                    int balance=0,bpm=0,bpc=0;
        			String ad12=new String("");
        			String ad13=new String("");
        			String ad14=new String("");
        			String ad15=new String("");
        			String ad16=new String("");
        			String ad17=new String("");
        			String ad18=new String("");
        			String ad19=new String("");
        			ResultSet rs12;
        			String[] words=null;
        			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        			Connection con1=DriverManager.getConnection("jdbc:odbc:encrypt","sa","test");
        		    Statement st=con1.createStatement();
        		    String sql12 = "select * from register where email='"+sid+"'" ;
        	 		st.executeQuery (sql12);
        	 		rs12 = st.getResultSet();
        			while (rs12.next ())
        				{
        				
        					
        					ad12=rs12.getString("dob");
        					ad14=rs12.getString("gender");
        					ad13=rs12.getString("iam");
        					ad15=rs12.getString("working");
        					
        					%>
        					  <tr>
                               <td>
                                Date of birth:
                              </td>
                              <td>
                                <%=ad12%>
                              </td>
                               
                               
                                </tr>
                                <tr>
                               <td>
                                Gender:
                              </td>
                              <td>
                                <%=ad13%>
                              </td>
                               
                               
                                </tr>
                                <tr>
                               <td>
                                Working as:
                              </td>
                              <td>
                                <%=ad14%>
                              </td>
                               
                               
                                </tr>
                                <tr>
                               <td>
                                Working at:
                              </td>
                              <td>
                                <%=ad15%>
                              </td>
                               
                               
                                </tr>
                                
        				<% System.out.println(ad12);
        				}%> 
                    
                    
                  
                        
                      
                  
                   
                   
                </table>
                
                
                </div>



</div>

	
						</div>
						
					    
				   </div>
				   
				   <div class="featured">
				        <ul>
							<li></li>
							<li></li>
							<li class="last"></li>
						</ul>
				        
				   </div>
				  
			
			</div>
			
			<div id="footer">
			        <div class="section">
						
					</div>
					<div id="footnote">
						
					</div>
			</div>
			
	
</body>
</html>